This forum is closed to new posts and
responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:
RE: How to get 7 values out of more than 2'000'000 documents ~Umberto Nongeroson 2.Dec.03 03:57 PM a Web browser Applications Development 6.0.2 CF2Windows 2000
I want to disagree with this response -- and I can! :-)
Adding one view sorted by user ID will not affect performance all that much. How many views does this database need? Maybe two in all? Does it even need another besides this one?
With a full-text index, it depends on what they're using for usernames, but the search will not necessarily return only the documents belonging to one user. E.g. if the username is "William Hoople", then the search [username] = "William Hoople" will also return records belonging to "James William Hoople", so the records require some post-processing to weed out the false matches.
The view also gives you the opportunity to do some extra sorting of the records (e.g. by date) so that you don't have to sort them in your program -- full-text results, on the other hand, you don't have so much control over what order you get them in.
Return to top
. . . . RE: How to get 7 values out of more... (~Bill Frokimari... 2.Dec.03) 
Print this page
